CREATE TABLE [dbo].[Batch]
(
[BATCH_NUM] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Batch_BATCH_NUM] DEFAULT (''),
[ORG_CODE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Batch_ORG_CODE] DEFAULT (''),
[STATUS] [tinyint] NOT NULL CONSTRAINT [DF_Batch_STATUS] DEFAULT ((0)),
[DESCRIPTION] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Batch_DESCRIPTION] DEFAULT (''),
[DATE_CREATED] [datetime] NULL,
[CREATED_BY] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Batch_CREATED_BY] DEFAULT (''),
[LAST_UPDATED] [datetime] NULL,
[UPDATED_BY] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Batch_UPDATED_BY] DEFAULT (''),
[CONTROLLED] [bit] NOT NULL CONSTRAINT [DF_Batch_CONTROLLED] DEFAULT ((0)),
[CONTROL_COUNT] [int] NOT NULL CONSTRAINT [DF_Batch_CONTROL_COUNT] DEFAULT ((0)),
[CONTROL_CASH] [money] NOT NULL CONSTRAINT [DF_Batch_CONTROL_CASH] DEFAULT ((0)),
[TRANS_COUNT] [int] NOT NULL CONSTRAINT [DF_Batch_TRANS_COUNT] DEFAULT ((0)),
[TRANS_CASH] [money] NOT NULL CONSTRAINT [DF_Batch_TRANS_CASH] DEFAULT ((0)),
[CASH_PSUEDO] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Batch_CASH_PSUEDO] DEFAULT (''),
[CASH_GL_ACCT] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Batch_CASH_GL_ACCT] DEFAULT (''),
[AR_PSUEDO] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Batch_AR_PSUEDO] DEFAULT (''),
[AR_GL_ACCT] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Batch_AR_GL_ACCT] DEFAULT (''),
[EFFECTIVE_DATE] [datetime] NULL,
[CASH_ENTITY] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Batch_CASH_ENTITY] DEFAULT (''),
[CASH_ACCOUNT_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Batch_CASH_ACCOUNT_CODE] DEFAULT (''),
[INTENT_TO_EDIT] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Batch_INTENT_TO_EDIT] DEFAULT (''),
[SOURCE_SYSTEM] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Batch_SOURCE_SYSTEM] DEFAULT (''),
[DUES_CYCLE_FLAG] [bit] NOT NULL CONSTRAINT [DF_Batch_DUES_CYCLE_FLAG] DEFAULT ((0)),
[MEETING] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Batch_MEETING] DEFAULT (''),
[HAS_EXPORTED_TRANS] [bit] NOT NULL CONSTRAINT [DF_Batch_HAS_EXPORTED_TRANS] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
CREATE CLUSTERED INDEX [iBatchBATCH_NUM] ON [dbo].[Batch] ([BATCH_NUM]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iBatchDATE_CREATED] ON [dbo].[Batch] ([DATE_CREATED]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iBatchSTATUS] ON [dbo].[Batch] ([STATUS]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Batch] TO [IMIS]
GRANT SELECT ON  [dbo].[Batch] TO [IMIS]
GRANT INSERT ON  [dbo].[Batch] TO [IMIS]
GRANT DELETE ON  [dbo].[Batch] TO [IMIS]
GRANT UPDATE ON  [dbo].[Batch] TO [IMIS]
GO